|
MobileDB User's Guide
Table of Contents
IntroductionMobileDB for the Pocket PC platform is the award-winning database application that allows users to view and edit any table or spreadsheet-like information on their Pocket PC device. MobileDB was designed for the handheld user that needs simple and efficient access to any size table or spreadsheet information. Using one of the many MobileDB tools such as MobileDB-PC, MobileDB-Excel or MobileDB-FileMaker, users can easily create MobileDB databases from comma separated file or nearly any another data source. Please visit http://www.handmark.com/products/mobiledb for a complete list of MobileDB tools. InstallationRun the MobileDB Installer and follow the on screen instructions. The installer installs the following files:
How to Install MobileDB databasesHundreds of MobileDB databases are available from our web site www.handmark.com/databases or directly from www.memoware.com. Once you have downloaded a database, simply save it in the "My Documents" folder on your Pocket PC device directly through the ActiveSync explore button. Registration and Technical SupportWhen you launch MobileDB you will be prompted to enter a serial number or to run in Trial mode. You may run the software for 15-days in full-functioning Trial mode. The Trial software and Registered software are identical. Once the trial period ends you must purchase and enter a serial number to continue using the software. You do not need to re-install the software. Simply enter a serial number and your Trial version will be converted into a Registered version. To purchase a product serial number, please visit our web site at www.handmark.com. Registration Once you purchase MobileDB, please register online at: www.handmark.com/register. Registering makes you eligible for free email technical support and for early notification when new product releases become available. Technical Support If you have a software problem you can't solve, please visit the Support section on our web site: www.handmark.com/support. If you need assistance from a technical support representative you can submit a request from this page. This release of MobileDB has many exciting features including:
Feature Overview
Limitations
MobileDB UsageTo begin using Handmark MobileDB, simply tap the MobileDB icon on your application screen. Enter your product serial number on the serial number screen and you're ready to use MobileDB. Until you purchase a product serial number, you can only use the application for 15 days. When first installed, the MobileDB
application will launch into the database list view. If you
previously exited the application while in a database, the same database
will be opened automatically on the next start up. This allows you to
access the same database repeatedly without having to reselect the
database. The database list view allows you to view the list of databases installed on your device, sort the list of databases, view the status of a database (size, date created, locked), or create a new database. To open a database for viewing or editing tap the database name in the database list. The database appears and you will see the 'Record List' view. To categorize a database, tap Info, then tap the database you want to categorize. Tap the Category box and select an existing category or create a new category. To create a new database
To sort the databases You can sort the databases by Name, Date, Size, and Type. Simply tap one of the sort options on the Sort By drop-down list located at the upper-right of the screen. tap Size on the Sort By drop down list at the upper-right of the screen. To change or assign databases to a
folder To rename a database To copy a database Tap and hold a database name, then tap Delete on the pop-up menu that appears. If you have the MobileDB Application Preference, "Confirm Database Delete" checked then a confirmation dialog box appears. Tap Yes when asked to confirm the deletion. If you do not have the "Confirm Database Delete" checked then the database is automatically deleted with no confirmation. We suggest that you keep the "Confirm Database Delete" checked unless you need to quickly delete a lot of databases. To beam a database Tap and hold the database name, then tap Beam File on the pop-up menu that appears. You can also beam a database from the record list view after opening a database. If in the record list view, tap Send Via Infrared on the Tools menu. To send a database via email Record List ViewScrolling Up or Down Records - Use the scroll bar or the device hard key to navigate up and down the records in the database. The record number indicator at the bottom of the screen (example: 735 of 890) displays the record number at the top of the screen. Since the application will not scroll past the last record location at the bottom of the screen, you will never see "890 of 890". You can scroll up or down a single record by tapping the up and down arrows at the top or bottom of the scroll bar. Scrolling Left or Right - If there are more than two fields in each record of your database then you can use the left or right arrows at the bottom-right of the screen to scroll through the "fields" or "columns" of the database. Selecting a Record - To select a record, simply tap the record and the record is highlighted, then navigate to the screen displaying the details of the record. Creating a New Record - To create a new record, tap New at the bottom left of the screen and the Edit Record screen appears. Enter the new information, then tap OK. The new record will be sorted properly in the new database. Modifying the Column Widths - To modify the widths of each column, drag the column width bar (line between each column name) to the new location. Exit - To return to the database list view, tap OK. Menu Functions Database Record Tools You can easily access application preferences from either the database list view or the record list view. Simply tap Preferences on the Tools menu in either the database list view or tap Preferences on the Database menu in the record list view. These preferences are for the entire application and are not dependent on the database selected. Confirm Record Delete - if checked, this will cause the application to pop up the 'Are You Sure' dialog after the user requests to delete a record. This may be unchecked if the user needs to quickly delete a lot of records in the database, however, we strongly suggest that the user keep this option checked during normal operation. Save New Databases To - On the drop-down list, select either Main Memory or Storage Card. This option allows you to save newly created databases to the device memory or to a storage card, if available. Alternating Row Color - This allows you to alternate colors between rows when listing records in a database. Use the drop down menu to select the color of your preference. Database OptionsYou can easily access the database preferences in the record list view. Simply tap Options on the Tools menu. Note that these preferences only effect the currently selected database, so you will need to set individual preferences for each database. Display Dates in Long Format - If this is checked then the dates in utilizing the date field types will be displayed as MM DD, YYYY instead of the default view MM/DD/YY On select, go to Edit View - If
this is checked when you select a record you will be taken to the edit
view instead of the view-only view. You can sort records in the record
list view. Simply tap Sort on the Record menu and the Sort Records
screen appears. Select the primary, secondary, and tertiary sort
criteria by selecting the field to sort. Select the Ascending or
Descending selection buttons if you would like that field to be sorted
in ascending or descending order. Once the sort criteria has been set,
tap OK to begin the sort. This may take a few seconds depending on the
number of records and complexity of the sort. Tap Cancel to cancel the
sort. The sort is based on the field types
selected. Therefore, if you want to sort chronologically then the field
you are sorting on must be a date field type. Filtering the records allows you to view only the records that contain specific text. To filter records, tap Filter on the Record menu in the record list view and the Filter Records screen appears. The filter options are based on the field data type you have selected. For text fields you can choose to filter text equal to (is) or containing (contains) the text you enter. For number field types you can filter a record that 'is', 'is not', 'is greater than', or 'is less than' the number entered. Checkbox is filtered as 'is' or 'is not' checked or unchecked and a list is filtered as 'is' or 'is not' one of the list items. The date and time fields are filtered based on 'is', 'is not', 'is before' or 'is after' the selected date or time. You can also choose to combine multiple filters as an 'and' requiring a match on all the filters or 'or' which just requires a match on one filter. If you already a filter on the current database then you'll have the option to apply the filter over the current filter (filtered rec's) or all the records in the database. Once you have entered your filter
criteria, tap OK to start the filter. To find a record that contains a
specific string of text, use the Find Record feature. Tap Find on the
Record menu. The Find Record screen appears, then you can enter the
find text and select the field on which to search for the text. Tap OK
and the Record List appears with the record highlighted with the the
text. To repeat the find, tap the small magnifying glass at the bottom
of the screen. The application will continue to search for the text
until it reaches the end of the database and it will prompt you to start
from the beginning of the database. To modify the widths of each column, drag the column width bar (line between each column name) to the new location. Tap Field Definitions on the Database menu from the Record List view to modify the field labels, data types, add a field, remove a field, or move a field, or in the database. MobileDB has 7 data type choices. Selecting the proper data type for your data will ensure maximum flexibility and consistency with the filter and sort functions The choices are text, number, list, checkbox, date, time, sequence. To change the data type of a field select a the data type from the list to the right of the entry field. Depending on the data type, an option pop-up dialog may appear. To change the field name of the field, simply edit the field name. HINT - Minimize the length of your field names (labels) in order to maximize the space available on the record view/edit screens. For instance change the field name "Description" to "Desc" to free up that much more screen space for your record details! To move a field in the database, select the field and use the arrow keys at the bottom of the screen to move the field up or down. To add a field to the end of the field list, tap the + at the bottom of the screen. To delete a field, tap the - at the bottom of the screen. Once any changes are made, it may take
a moment to make the changes in every record in the database.
To lock a MobileDB database, select the database and then tap Change Password on the Database menu. Leave the "Old Password" field blank (since there is no password set) and enter your password in the "New Password" and "Retype New" fields. The next time a that database is selected, you will be prompted to enter a password before viewing or editing the database. NOTE: This "lock" simply hides the database from view in the MobileDB application. If someone is interested enough in this information, they can simply sync your device and view the database on the PC using an ASCII viewer or any MobileDB converter. DO NOT PLACE ANY SENSITIVE INFORMATION IN THIS APPLICATION WITH THE ASSUMPTION THAT "LOCKING" IT WILL SECURE THE INFORMATION. Company InformationHandmark, Inc., is rapidly emerging as the leading publisher of consumer applications for Palm and Pocket PC handheld devices. Handmark offers consumer software for PDAs through major retail chains in North America as well as through its web site: www.handmark.com. Handmark software is available in the U.S. and Europe and will soon be sold in Australia. In the U.S. Handmark sells through both national and regional retail stores including Best Buy, CompUSA, Fry's, Staples, Micro Center, J&R Music World, RCS, and others. Handmark software is compatible with Palm OS handheld computers from Palm, Inc., Handspring, and IBM as well as other licensees of the Palm OS platform including new devices from Sony. The desktop components of Handmark applications are compatible with Apple Macintosh and Microsoft Windows personal computers. Please see the Handmark web site for more information. License AgreementLEASE READ THIS LICENSE CAREFULLY BEFORE USING HANDMARK SOFTWARE. BY USING THE HANDMARK SOFTWARE, YOU AGREE TO BECOME BOUND BY THE TERMS OF THIS LICENSE IF YOU DO NOT AGREE TO THE TERMS OF THIS LICENSE, DO NOT USE THE HANDMARK SOFTWARE. The Handmark software ("Software") provided along with this License, is licensed, not sold, to you by Handmark Software Incorporated ("Handmark") for use only under the terms of this License, and Handmark reserves any rights not expressly granted to you. You own the media on which the Software is recorded, but Handmark and its licensors retain ownership of the Software itself. 1. License. This License allows you to: (a) Use one
copy of the Software on a single computer at a time To "use" the
Software means that the Software is either loaded in the temporary
memory of a computer or installed on the permanent memory of a computer.
You may install the Software on a common storage device which is
accessible by multiple computers, provided that if more computers
have access to the common storage device than the number of licensed
copies of the Software, you must have some software mechanism which
locks-out any concurrent users in excess of the number of licensed
copies of the Software and additional license is not needed for
the one copy of Software installed on the common storage device
accessed by multiple computers) 2. Restrictions. The Software contains trade secrets in its human perceivable form and, to protect them, you may not REVERSE ENGINEER, DECOMPILE, DISASSEMBLE OR OTHERWISE REDUCE THE SOFTWARE TO ANY HUMAN PERCEIVABLE FORM YOU MAY NOT MODIFY, ADAPT, TRANSLATE, RENT, LEASE, LOAN OR CREATE DERIVATIVE WORKS BASED UPON THE SOFTWARE OR ANY PART THEREOF 3. Termination. This License is effective until terminated This License will terminate immediately without notice from Handmark or judicial resolution if you fail to comply with any provision of this License Upon such termination you must destroy the Software, all accompanying written materials and all copies thereof, and Sections 5, 6 and 7 will survive any termination 4. Limited Warranty. Handmark warrants for a period of ninety (90) days from your date of purchase that the Software as provided by Handmark will substantially conform to Handmark's published specifications for the Software Handmark's entire liability and your sole and exclusive remedy for any breach of the foregoing limited warranty will be, at Handmark's option, replacement of the media (if any), refund of the purchase price (based on fair market value of the Software) or repair or replacement of the Software. THIS LIMITED WARRANTY IS THE ONLY WARRANTY PROVIDED BY HANDMARK AND HANDMARK AND ITS LICENSORS EXPRESSLY DISCLAIM ALL OTHER WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO IMPLIED WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE WITH REGARD TO THE SOFTWARE AND ACCOMPANYING WRITTEN MATERIALS. BECAUSE SOME JURISDICTIONS DO NOT ALLOW THE EXCLUSION OR LIMITATION OF IMPLIED WARRANTIES, THE ABOVE LIMITATION MAY NOT APPLY TO YOU. 5. Limitation of Remedies and Damages. IN NO EVENT WILL HANDMARK OR ANY OF THE LICENSORS, DIRECTORS, OFFICERS, EMPLOYEES OR AFFILIATES OF ANY OF THE FOREGOING BE LIABLE TO YOU FOR ANY CONSEQUENTIAL, INCIDENTAL, INDIRECT OR SPECIAL DAMAGES WHATSOEVER (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF BUSINESS PROFITS, BUSINESS INTERRUPTION, LOSS OF BUSINESS INFORMATION AND THE LIKE), WHETHER FORESEEABLE OR UNFORESEEABLE, ARISING OUT OF THE USE OF OR INABILITY TO USE THE SOFTWARE OR ACCOMPANYING WRITTEN MATERIALS, REGARDLESS OF THE BASIS OF THE CLAIM AND EVEN IF HANDMARK OR A HANDMARK REPRESENTATIVE HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. Handmark's liability to you for direct damages for any cause whatsoever, and regardless of the form of the action, will be limited to the greater of $500 or the money paid for the Software (based on fair market value of the Software) that caused the damages. THIS LIMITATION WILL NOT APPLY IN CASE OF PERSONAL INJURY ONLY WHERE AND TO THE EXTENT THAT APPLICABLE LAW REQUIRES SUCH LIABILITY BECAUSE SOME JURISDICTIONS DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CON-SEQUENTIAL OR INCIDENTAL DAMAGES, THE ABOVE LIMITATION MAY NOT APPLY TO YOU. 6. General. This License will be construed under the laws of the State of Missouri, except for that body of law dealing with conflicts of law If any provision of this License shall be held by a court of competent jurisdiction to be contrary to law, that provision will be enforced to the maximum extent permissible, and the remaining provisions of this License will remain n full force and effect If you are a U S Government user then the Software is provided with "RESTRICTED RIGHTS" as set forth in subparagraphs (c) (l) and( 2) of the Commercial Computer Software Restricted Rights clause at FAR52227-19 o sub paragraph (c) (1) (ii) of the Rights in Technical Data and Computer Software clause at DFARS 52 277-7013, as applicable Manufacturer Handmark, Incorporated 105 East 5th Street, Suite 201, Kansas City, MO 64106. Handmark
MobileDB Serial Number
|
